package com.qingcheng.dao;

import com.qingcheng.pojo.order.TradeStatistics;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface TradeStatisticsMapper extends Mapper<TradeStatistics> {

    /**
     * 查询最近30条记录,并倒序排列
     * @return
     */
    @Select("SELECT * FROM tb_trade_statistics ORDER BY id DESC LIMIT 0,30 ")
    public List<TradeStatistics> findOneMonth();
}
